
if exists(select name from sysobjects where name = 'sp_SinhVienDangNhap')
	drop proc sp_SinhVienDangNhap
go
/*
	Created by: Phuoc NH
	Created on: 13/05/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_SinhVienDangNhap.sql
*/

create proc sp_SinhVienDangNhap
@MaSinhVien varchar(50),
@MatKhau varchar(100)
as
begin
	select MaSinhVien, Ho+' '+Ten as HoTen, MaLop from SinhVien where MaSinhVien=@MaSinhVien and MatKhau=@MatKhau and TrangThai<>'0'
end

